2014-07-01- 8009.700 - Rel Notes - Final - SAP POS Extract #SAPReleases2014

Release Notes - Draft / Final

8009.700 -Spec- SAP POS Extract

Admin Info

Purpose	Modify the ZIMM_XML_INVENTORY_OUTPUT to trigger the material if ZMRP value is changed and to fetch the value from A552 table and remove the logic of fetching from SO.
Release No	002
Submitted on	07/01/2014
Submitted by	Deepak Yasam
Environment	NECNED to NECNEQ
Sent To	Craig Spangler
Object(s) created by	Prudvi Mandadi
Object(s) tested by	Deepak Yasam
Transport Status	Created in NECNED100

Transport and Technical Objects

Sl.	Transport ID	Description	Object Name
1	NEDK926599	SD:8009:Update the program to fetch ZMRP from A552 table	ZIMM_XML_INVENTORY_OUTPUT

Release Notes

For Infrastructure

Below is the TR that needs to be imported to NEQ/NEP prior to the above TR.

NEDK926254 SD:8009:Update the inventory extract with new values

For Requestor

The program ZIMM_XML_INVENTORY_OUTPUT needs to be modified with certain changes as mentioned in the spec document by NE.Below are the new changes that needs to be done.

1. Currency_nameshould reflect GBP or EUR 2. udf2_value should be PH level 1

3. DCS Code Department – Product Hierarchy Level 1 Class – Product Hierarchy Level 2 Sub Class – Product Hierarchy Level 3 Must be a full 8 characters, spaces can divide PH levels dcs_code="01 26 M "

4.UDF field changes

INVN_SBS_SUPPL udf_no="1" udf_value=""/>
INVN_SBS_SUPPL udf_no="2" udf_value=""/>
INVN_SBS_SUPPL udf_no="3" udf_value="BASEBALL - ON FIELD"/> PH1
INVN_SBS_SUPPL udf_no="4" udf_value="MALE"/> PH3
INVN_SBS_SUPPL udf_no="5" udf_value="5950"/> PH4
INVN_SBS_SUPPL udf_no="6" udf_value="BASEBALL"/> PH5
INVN_SBS_SUPPL udf_no="7" udf_value="MLB PROPERTIES"/> PH6
INVN_SBS_SUPPL udf_no="8" udf_value="BALTIMORE ORIOLES"/> PH7
INVN_SBS_SUPPL udf_no="9" udf_value="GAME"/> PH8
INVN_SBS_SUPPL udf_no="10" udf_value="STS"/> Season
INVN_SBS_SUPPL udf_no="11" udf_value="100"/> collection
INVN_SBS_SUPPL udf_no="12" udf_value="AC1"/> Material Group 1
INVN_SBS_SUPPL udf_no="13" udf_value="200"/> Material Group 2
INVN_SBS_SUPPL udf_no="14" udf_value="RED"/> Material Group 3

5.Pricing INVN_SBS_PRICE price_lvl="1" price="34.99" Should reflect MSRP INVN_SBS_PRICE price_lvl="2" price="0.00" No need to populate 6. GBP will be sbs_no 1 and EUR will be sbs_no 2
6. The ZMRP value should be considered from the A552 table but not from the SO.While considering the value the latest price record should be dispalyed.
7.The change in ZMRP should trigger the material in the output.

Test Notes

System : NECNED300

Test ID	Test Scenario	Expected Results	Actual Results	P/F	Documents	Notes	Tested By	QA By
SD-001	Execute the program with date as selection and retail orders check box flagged ,with 2000 sales org and EUR in the selection screen.	1.All the materials with changes in like customer material number, material description, product attribute 5 , ZMRP value would be dispalyed in the output file. 2.Retail orders that were created greater than yesterdays date with customer group 7 ie., 010 and materials attribute 5 flagged should be considered and the materials should be dispalyed in the output.	1. The materials with the specified changes with todays date are displayed. 2.The materials from the retail orders that were created greater than yesterdays date with customer group 7 ie., 010 and materials attribute 5 flagged are co nsidered and dispalyed in the output.	P	Material Change 10000219 - Mat.des 10000218 - ZMRP 10017591 - Retail(Material attribute 5) 2.Material - 10017592 Test1.xml	N/A	Deepak yasam	Surya Basa
SD-002	Execute the program with date as selection and retail orders check box unflagged,with 2000 sales org and GBP in the selection screen.	The material with latest ZMRP value should be dispalyed in the file.	The material with latest ZMRP value is be dispalyed in the file.	P	Along with other changes like material description ,retail attribute the latest ZMRP value changes are considered. Material - 10017596 (earlier value - 33.33 and new value - 11.12) New value is dispalyed in the file. Test2.xml	N/A	Deepak yasam	Surya Basa
SD-003	Execute the program with single material and with retail orders check box ,with 2000 sales org and GBP in the selection screen.	All the specified fields should be updated with the new values and ZMRP value should be printed A552 table but not from the SO for the given specific material .	Currency field is printed with GBP ,sbs_no is printed with 1 and remaining fields are printed as required.ZMRP value from A552 table is considered and printed in the file.	P	Material - 10017598 The SO ZMRP value is 19.99 GBP and the A552 table value is 23.33 GBP. The A552 table value is considered and printed in the file. Test3.xml	N/A	Deepak yasam	Surya Basa
SD- 004	Execute the program with single material and with retail orders check box ,with 2000 sales org and EUR in the selection screen.	All the materials specified fields should be updated with the new values and the materials with no ZMRP value mainatined in A552 table shouldn't be dispalyed in the file.	All the specified fields are updated with the new values for all the materials and the materials with no ZMRP value mainatined in A552 table is not dispalyed in the file.	P	Material - 10017623 No ZMRP value mainatined for the above material in A552 table and when the program is executed it is not dispalyed in the file. Test4.xml	N/A	Deepak Yasam	Surya Basa

System: NECNEQ100

None

Reference Document (Specification or Production Support Break Fix)

Deepak - 2014-05-29 - 8009.200 - Spec - POS Integration